package com.example.logistics_oa.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.example.comment_oa.pojos.JobcorresSubsidy;
import com.example.comment_oa.pojos_vo.BuTieChaXunVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author 安徽彭于晏
* @description 针对表【jobcorres_subsidy】的数据库操作Service
* @createDate 2022-10-17 17:28:00
*/
public interface JobcorresSubsidyService extends IService<JobcorresSubsidy> {
    public List<JobcorresSubsidy> selectAll(@Param("BuTieChaXunVo") BuTieChaXunVo buTieChaXunVo);

    public int updateButieStatus(@Param("jcsId") int jcsId);

    public int updateButieStatusQi(@Param("jcsId") int jcsId);

    public int updateButieMoney(@Param("jcsMoney") Double jcsMoney,@Param("jcsId") int jcsId);


    public List<JobcorresSubsidy> selectZhiWeiIdAndName();

    public int insertJiLu(@Param("JobcorresSubsidy")JobcorresSubsidy jobcorresSubsidy);

    public JobcorresSubsidy selectOneByJcsjobid(@Param("jcsjobid")int jcsjobid);

    public List<JobcorresSubsidy> selectBumenAndBumenName();

    public List<JobcorresSubsidy> selectGenJuTiaoJian(@Param("jcsDepartmentid")int jcsDepartmentid,@Param("jcsDepartmentname")String jcsDepartmentname,@Param("jcsMoney")Double jcsMoney);

    public List<JobcorresSubsidy> selectBuTieXiangQing(@Param("jcsJobid")int jcsJobid,@Param("jcsDepartmentid")int jcsDepartmentid);

    public List<JobcorresSubsidy> selectBuTieXiangQingAnd(@Param("jcsJobid")int jcsJobid,@Param("jcsDepartmentid")int jcsDepartmentid);

}
